Even So the next portion I am having difficulties to try and do after the mass copy and paste has run I would like another code that can update column A accordingly such the Task num from sheet two will fill in to each between responsibilities 2 and 10,000 I Successfully Submitted (Awaiting Approval)